<%-- 
    Document   : edit
    Created on : Jun 19, 2012, 11:33:01 PM
    Author     : karuna
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*,java.io.*" %>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");

         Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","pac","mca"); 

         Statement stmt=con.createStatement();
        String question="";
        String company_name="";
String str=request.getParameter("college_code");


         ResultSet rs = stmt.executeQuery("select * from imp_cmp where college_code='"+str+"'"); 
         if(rs.next())

         {
                company_name=rs.getString("company_name");
                question=rs.getString("question");
             
      }
            
        %>
       

<html>


<head>  
      
       <br><br>
      <center>  <h1>   </h1> <center>

     <STYLE Type="text/css">
			TD {Text-Align:Left; Font-Size:16pt}
			.chk:focus{
			   background-color:brown;
			  }

                  
      </style>
</head>

<body background="t5.jpg"><center>
<table height="100%" width="70%" bgcolor="white">
<tr><td>from</td></tr>
<tr><td><br><%out.println(company_name);%></td></tr><td>
<tr><td><br>These are Requirements ...</td>
<tr><td></td></tr>
<tr><td></td></tr>
<td>
<% 
           
          out.println(question);
   
             %></td>
</tr>
<tr><td><form action="forward.jsp"><input type="hidden" name="college_code" value="<%=str%>"/>
<input type="hidden" name="question" value="<%=question%>"/>
<input type="hidden" name="company_name" value="<%=company_name%>"/>
<input type="submit" value="forward"/></form></table></center>
<h3>




</h3></body></html>
